GRP-#WINDOW-SYMBOLcCALLDESCRIPTION-------------- 111123333333333333dGRP-4444444444444444444444444 * * codes: L = enter literal value F = enter .format literal/close paren P = Parentheses handling C = Conditional Fields (.if) c = Conditional Fields (2nd half) R = Read another file D = Display Layout Fields 0 = Stay in same level after call 1 = Return one level to previous menu -----WHAT TO PRINT WINDOWS----------------------|A A1 Special Commands |A B ... field names ... |-Call Groups------------------------------------|A1 RBB Field from another File |A1 PBA Use parentheses |A1 A11 Special values |A1 LB Enter literal text value |A1 1 Return to previous window|------------------------------------------------|A11 "\d" B System Date |A11 "\t" B System Time |A11 "\p" B Page Number |A11 "\r" B Force a new line |A11 "\n" B Force a new page |A11 1 Return to previous window|------------------------------------------------|B ESC When done with entry |B B1 Next Field |B B2 Arithmetic |B 0B3 Field modifiers |------------------------------------------------|B1 , Next Field with Space |B1 ; Next Field with No Space |B1 1 Return to previous window|------------------------------------------------|B2 + Addition |B2 - Subtraction |B2 * Multiplication |B2 / Division |B2 ** Raise to the Power of |B2 1 Return to previous window|------------------------------------------------|B3 B4 Calculated Fields |B3 B5 Date commands |B3 .if( CB6 Conditional Fields (.if) |B3 .level B4A Only print if level break|B3 B7 Multiple records per line|B3 1 Return to previous window|-3 .font B4C Printer Font |-3 .format( F Special Output Format |------------------------------------------------|B4 .balance B4A Running Balance Total |B4 .pct B4A Percent of Total [n] |B4 .dev B4A Deviation from Average |B4 .total B4A Total (sub or grand) |B4 .avg B4A Average Amount |B4 .count B4A Count of Records |B4 .tally B4A Record Number |B4 .max B4A Maximum Value |B4 .min B4A Minimum Value |B4 .selection B4B Selection Criteria Value |B4 1 Return to previous window|-4 .bar Horizontal Bar Graph |------------------------------------------------|B4A [1] Based on Subtotal Level 1|B4A [2] Based on Subtotal Level 2|B4A [3] Based on Subtotal Level 3|B4A [4] Based on Subtotal Level 4|B4A [5] Based on Subtotal Level 5|B4A [6] Based on Subtotal Level 6|B4A [7] Based on Subtotal Level 7|B4A [8] Based on Subtotal Level 8|B4A [9] Based on Subtotal Level 9|------------------------------------------------|B4B [1] First Selection Value |B4B [2] Second Selection Value |B4B [3] Third Selection Value |B4B [4] Fourth Selection Value |B4B [5] Fifth Selection Value |B4B [6] Sixth Selection Value |B4B [7] Seventh Selection Value |B4B [8] Eighth Selection Value |B4B [9] Ninth Selection Value |------------------------------------------------|B4C [1] First Printer Font |B4C [2] Second Printer Font |B4C [3] Third Printer Font |B4C [4] Fourth Printer Font |B4C [5] Fifth Printer Font |B4C [6] Sixth Printer Font |B4C [7] Seventh Printer Font |------------------------------------------------|B5 .age Current Age of Date |B5 .days Julian Days of Date(1900)|B5 .date Date of Julian Days(1900)|B5 .days[2] Julian Days of Date(yr 0)|B5 .date[2] Date of Julian Days(yr 0)|B5 .time Seconds to HH:MM:SS |B5 1 Return to previous window|------------------------------------------------|B6 = B62 Equal To |B6 < B62 Less Than |B6 <= B62 Less Than or Equal To |B6 > B62 Greater Than |B6 >= B62 Greater Than or Equal To |B6 <> B62 Not Equal To |B6 @ B62 Containing |B6 # B62 Not Containing |B6 .agerange B63 In Age Range Of |------------------------------------------------|B61 ESC When done with entry |B61 & And |B61 : Or |------------------------------------------------|B62 LB61 Enter literal text value |B62 ? cB61 Value of a Field |B62 1 Return to previous window|------------------------------------------------|B63 [,30] B61 Less than 30 days old |B63 [31,60] B61 31 to 60 days old |B63 [61,90] B61 61 to 90 days old |B63 [91,] B61 Over 90 days old |B63 [91,120] B61 91 to 120 days old |B63 [121,] B61 Over 120 days old |------------------------------------------------|B7 .1 First Record on line |B7 .2 Second Record on line |B7 .3 Third Record on line |B7 .4 Fourth Record on line |B7 .5 Fifth Record on line |B7 .6 Sixth Record on line |B7 .7 Seventh Record on line |B7 .8 Eighth Record on line |B7 .9 Ninth Record on line |------------------------------------------------|BA ESC Close parenthesis |BA B1 Next Field |BA B2 Arithmetic |BA 0B3 Field modifiers |------------------------------------------------|BB ESC Done with the second file|BB B1 Next Field |BB B2 Arithmetic |BB 0B3 Field modifiers |------------------------------------------------|C1A RL2B Field from another File |C1A PL2A Use parentheses |C1A L11 Special values |C1A LL2 Enter literal text value |C1A ESC Complete Field Choices |C1A 1 Return to previous window|------------------------------------------------|C1B ESCe Change position in layout|C1B ESCb Center this line |C1B ESCc Insert a new line |C1B ESCd Delete a line |C1B ESC Begin full-screen editing|C1B 1 Return to previous window|------------------------------------------------|C1C ESCg Translate to Query/Report|C1C ESCh Fast exit, no translation|C1C 1 Return to previous window|------------------------------------------------|CBTY Fixed Length Records |CBTY R RM COBOL Version 1 |CBTY 1 RM COBOL V.2 Single file |CBTY 2 RM COBOL V.2 Dual file |CBTY 8 RM COBOL Version 8X/85 |CBTY 9 AcuCobol Indexed file |CBTY J Realia Cobol Indexed file|CBTY S Micro Focus COBOL |CBTY U Micro Focus COBOL/2 |------------------------------------------------|DEST S Screen |DEST P Printer |DEST L Letter Single Sheet Feed |DEST D Disk File |DEST A Automatic Disk File |DEST T dBASE II DBF File |DEST U dBASE III DBF File |DEST V Visicalc DIF File |DEST W Lotus WKS File |DEST X Perfect Calc File |DEST Y Multiplan SYLK File |DEST Z C-Basic ASCII File |DEST ^ M-Basic ASCII File |DEST ? Prompt for Destination |------------------------------------------------|DFMT Normal Display Format |DFMT 0 COBOL COMP |DFMT 1 COBOL COMP-1 |DFMT 3 COBOL COMP-3 |DFMT 6 COBOL COMP-6 |DFMT ^ DataFlex numerics & dates|DFMT ! MS-BASIC Single Precision|DFMT # MS-BASIC Double Precision|DFMT % 2 byte integer |DFMT & Reverse order 2 byte int.|DFMT 4 4 byte int. (Tandy BASIC)|DFMT 8 8 byte int. (Tandy BASIC)|DFMT A ASCII Character (0 - 255)|DFMT B Signed byte (-128 to 127)|DFMT C COBOL Combined Sign |DFMT D Floating Point (Double) |DFMT E COBOL COMP-4 |DFMT F Floating Point (Single) |DFMT G BCD Packed Numbers |DFMT H Informix Small Integer |DFMT I Short Integer |DFMT L Long Int/Realia COMP-5 |DFMT M Informix Double "Money" |DFMT N Null terminated strings |DFMT P Lattice C-Food Packed |DFMT R Turbo PASCAL 6 byte real |DFMT S Sign Separate |DFMT W Realia COMP-4 S9(9) |DFMT X Realia COMP-4 S9(18) |DFMT Z Realia COMP-5 S9(18) |DFMT Y Date stamp (MSDOS FCB) |DFMT T Time stamp (MSDOS FCB) |DFMT U Unsigned short integer |DFMT V Micro Focus COBOL COMP |DFMT > MS-FORTRAN Decimal Double|DFMT < MS-FORTRAN Decimal Single|DFMT ~ Informix Float |DFMT * Informix Decimal |------------------------------------------------|FDTY A Alphanumeric field |FDTY L Lower Case (Alpha) |FDTY U Upper Case (Alpha) Shift |FDTY P Telephone Number |FDTY PE Telephone # and Extension|FDTY G GPS Account Number |FDTY N Number w/commas, (no 0's)|FDTY N- Signed number with commas|FDTY # Number w/commas,0's print|FDTY #- Signed number with commas|FDTY * Number w/o commas, no 0's|FDTY *- Signed number w/o commas |FDTY @ Number no commas,0 prints|FDTY @- Signed no commas,0 prints|FDTY 1 1 decimal place |FDTY 1- Signed / 1 decimal place |FDTY 2 2 decimal places |FDTY 2- Signed / 2 decimal places|FDTY 3 3 decimal places |FDTY 3- Signed / 3 decimal places|FDTY 4 4 decimal places |FDTY 4- Signed / 4 decimal places|FDTY 5 5 decimal places |FDTY 5- Signed / 5 decimal places|FDTY 6 6 decimal places |FDTY 6- Signed / 6 decimal places|FDTY 7 7 decimal places |FDTY 7- Signed / 7 decimal places|FDTY 8 8 decimal places |FDTY 8- Signed / 8 decimal places|FDTY 9 9 decimal places |FDTY 9- Signed / 9 decimal places|FDTY D Default date format |FDTY T Time Stamp (HH:MM:SS) |FDTY Q Question ("Y" or "N") |FDTY AH Hex format |FDTY DM Date format mmddyy |FDTY Da Date format: mm/dd/yy |FDTY Db Date format: ddlllyy |FDTY Dc Date format: yynnn |FDTY Dd Date format: yy/mm/dd |FDTY De Date format: dd/mm/yy |FDTY Df Date format: ddlllccyy |FDTY Dg Date format: dd/mm/ccyy |FDTY Dh Date format: ccyymmdd |FDTY Di Date format: yymmdd |FDTY Dj Date format: ccyynnn |FDTY Dk Date format: mm/dd/ccyy |FDTY Dl Date format: dd lll yy |FDTY Dm Date format: dd lll ccyy |FDTY Dn Date format: lll dd, yy |FDTY Do Date format: lll dd, ccyy|FDTY Dp Date format: dd.mm.yy |FDTY Dq Date format: dd.mm.ccyy |FDTY Dr Date format: mm.dd.yy |FDTY Ds Date format: mm.dd.ccyy |FDTY Dt Date format: jjjjjj |FDTY Du Date format: ddmmyy |FDTY Dv Date format: ddoyy- |FDTY Dw Date format: bitmap 1 |FDTY Dx Sens Solns Date: jjjjjj |FDTY Dz Elapsed (ZDAYS): jjjjjj |------------------------------------------------|FLTY Fixed Length Records |FLTY A Variable Length ASCII |FLTY B Variable Length Binary |FLTY C C-BASIC Comma Delimited |FLTY D dBASE II |FLTY E dBASE III |FLTY F DataFlex (version 2.1) |FLTY G DataFlex (vers 2.2, 2.3) |FLTY g C Tree |FLTY I Informix |FLTY i Inside Out |FLTY J Realia Cobol Indexed file|FLTY L Lotus WKS file |FLTY M MicroSoft COBOL Relative |FLTY N MicroSoft COBOL Indexed |FLTY O Open Systems Version 2 |FLTY P MBP COBOL |FLTY R RM COBOL Version 1 |FLTY T BTRIEVE files |FLTY U Micro Focus COBOL/2 |FLTY V MBP Visual COBOL-85 |FLTY X BBx DIRECT and MKEYED |FLTY 1 RM COBOL V.2 Single file |FLTY 2 RM COBOL V.2 Dual file |FLTY 8 RM COBOL Version 85 file |FLTY 9 AcuCobol Indexed file |-----THIS INFO FIELDS---------------------------|IA IA1 Special Commands |IA IB ... field names ... |-Call Groups------------------------------------|IA1 RIB1 Field from another File |IA1 PIB0 Use parentheses |IA1 LIB Enter literal text value |IA1 ESC When done with entry |IA1 1 Return to previous window|------------------------------------------------|IB , Next Field |IB IB2 Arithmetic |IB 0IB3 Field Modifiers |IB ESC When done with entry |------------------------------------------------|IB0 , Next Field |IB0 IB2 Arithmetic |IB0 0IB3 Field Modifiers |IB0 ESC Close parenthesis |------------------------------------------------|IB1 , Next Field |IB1 IB2 Arithmetic |IB1 0IB4 Date commands |IB1 ESC Done with the second file|------------------------------------------------|IB2 + Addition |IB2 - Subtraction |IB2 * Multiplication |IB2 / Division |IB2 ** Raise to the Power of |IB2 1 Return to previous window|------------------------------------------------|IB3 .SUM Sum this field |IB3 .age Current Age of Date |IB3 .days Julian Days of Date |IB3 .date Date of Julian Days |IB3 .time Seconds to HH:MM:SS |IB3 1 Return to previous window|------------------------------------------------|IB4 .age Current Age of Date |IB4 .days Julian Days of Date |IB4 .date Date of Julian Days |IB4 1 Return to previous window|-----LAYOUT FIELD SELECTION WINDOWS-------------|L L1 Special Commands |L L2 ... field names ... |-Call Groups------------------------------------|L1 C1B Editing Commands |L1 D Show Fields in Layout |L1 C1A Special Field Commands |L1 ESCa Change Report Format |L1 C1C Exit Layout Program |L1 1 Return to previous window|------------------------------------------------|L11 "\d" L2 System Date |L11 "\t" L2 System Time |L11 "\p" L2 Page Number |L11 "\r" L2 Force a new line |L11 "\n" L2 Force a new page |L11 1 Return to previous window|------------------------------------------------|L2 ESC Complete Field Choices |L2 .break 0 Set Field as Total Break |L2 0L3 Modify Field Further |L2 + Add to Field |L2 - Subtract from Field |L2 * Multiply by Field |L2 / Divide by Field |L2 ** Raise to the Power of |L2 , Combine Fields with Space|L2 ; Combine Fields no Space |------------------------------------------------|L2A ESC Close parenthesis |L2A .break 0 Set Field as Total Break |L2A 0L3 Modify Field Further |L2A + Add to Field |L2A - Subtract from Field |L2A * Multiply by Field |L2A / Divide by Field |L2A ** Raise to the Power of |L2A , Combine Fields with Space|L2A ; Combine Fields no Space |------------------------------------------------|L2B ESC Complete File Choices |L2B .break 0 Set Field as Total Break |L2B 0L3 Modify Field Further |L2B + Add to Field |L2B - Subtract from Field |L2B * Multiply by Field |L2B / Divide by Field |L2B ** Raise to the Power of |L2B , Combine Fields with Space|L2B ; Combine Fields no Space |------------------------------------------------|L3 B4 Calculated Fields |L3 B5 Date commands |L3 .if( CL6 Conditional Fields (.if) |L3 .level B4A Only print if level break|L3 B7 Multiple records per line|L3 .suppress Suppress Line if Blank |L3 .invisible Make Invisible |L3 .center Center the Field |L3 .expand Expand the Field |L3 1 Return to previous window|-3 .array[1,1] Define an Array Field |-3 .is PBA Is Now the Following |-3 .font B4C Printer Font |-3 .format( F Special Output Format |------------------------------------------------|L6 = L62 Equal To |L6 < L62 Less Than |L6 <= L62 Less Than or Equal To |L6 > L62 Greater Than |L6 >= L62 Greater Than or Equal To |L6 <> L62 Not Equal To |L6 @ L62 Containing |L6 # L62 Not Containing |L6 .agerange L63 In Age Range of |------------------------------------------------|L61 ESC When done with entry |L61 & And |L61 : Or |------------------------------------------------|L62 LL61 Literal Text Value |L62 cL61 Value of a Field |L62 1 Return to previous window|------------------------------------------------|L63 [,30] L61 Less than 30 days old |L63 [31,60] L61 31 to 60 days old |L63 [61,90] L61 61 to 90 days old |L63 [91,] L61 Over 90 days old |L63 [91,120] L61 91 to 120 days old |L63 [121,] L61 Over 120 days old |------------------------------------------------|LTYP D Detail Line |LTYP H Page Header Line |LTYP F Page Footer Line |LTYP 1 Subtotal Level 1 |LTYP 2 Subtotal Level 2 |LTYP 3 Subtotal Level 3 |LTYP 4 Subtotal Level 4 |LTYP 5 Subtotal Level 5 |LTYP 6 Subtotal Level 6 |LTYP 7 Subtotal Level 7 |LTYP 8 Subtotal Level 8 |LTYP 9 Subtotal Level 9 |-----RELATIONSHIP MAINTENANCE WINDOWS-----------|RA RA1 Special Commands |RA RB ... field names ... |-Call Groups------------------------------------|RA1 LRBA Enter literal text value |RA1 PRBA Use parentheses |RA1 1 Return to previous window|------------------------------------------------|RB -> RBB Many-to-One Keyed Read |RB -> RBB One-to-One Keyed Read |RB +> RBB One-to-Many Keyed Read |RB => RBB Direct Read |RB *> RBB One-to-Many Direct Chain |RB ->> RBB M-t-O Native Keyed Read |RB ->> RBB O-t-O Native Keyed Read |RB +>> RBB O-t-M Native Keyed Read |RB *>> RBB O-t-M Native Direct Chain|RB 1 Return to previous window|------------------------------------------------|RBA ESC Close parenthesis |RBA , Next field |RBA 1 Return to previous window|------------------------------------------------|RBB ESC When done with entry |------------------------------------------------|RLT -> Many-to-One Keyed Read |RLT -> One-to-One Keyed Read |RLT +> One-to-Many Keyed Read |RLT => Direct Read |RLT *> One-to-Many Direct Chain |-----SELECTION CRITERIA WINDOWS-----------------|SEL SEL1Special Commands |SEL SEL2... field names ... | B4 Calculated Fields |------------------------------------------------|SEL1 ESC Include all records |SEL1 rSEL2Field from another File |SEL1 pSEL2Use parentheses |SEL1 ESC Done with choose when |SEL1 1 Return to previous window|------------------------------------------------|SEL2 = SEL4Equal To |SEL2 < SEL4Less Than |SEL2 <= SEL4Less Than or Equal To |SEL2 > SEL4Greater Than |SEL2 >= SEL4Greater Than or Equal To |SEL2 <> SEL4Not Equal To |SEL2 @ SEL4Containing |SEL2 # SEL4Not Containing |SEL2 .days 0 Julian Days of Date |SEL2 .date 0 Date of Julian Days |SEL2 .age 0 Current Age of Days |------------------------------------------------|SEL3 ESC When done with entry |SEL3 & And |SEL3 : Or |------------------------------------------------|SEL4 LSEL3Literal Text Value |SEL4 ? cSEL3Variable Select Criteria |SEL4 cSEL3Value of a Field |SEL4 1 Return to previous window|-----SORT-FIELDS-WINDOWS------------------------|SRT SRT1Special Commands |SRT SRT2... field names ... |------------------------------------------------|SRT1 ESC Done with Sort Fields |SRT1 , Next Sort Field |------------------------------------------------|SRT2 .ascend SRT1In Ascending Order |SRT2 .descend SRT1In Descending Order |------------------------------------------------|